﻿-- =============================================
-- Author:		<赵洪涛>
-- Create date: <2012-07-02>
-- Description:	<批量设置项目跟进人员>
-- =============================================
Create PROCEDURE [dbo].[proc_Project_BatUpdate_GenJinKf] 
(
	@Order_Id varchar(200),
	@GenJinKfAccount varchar(20),
	@GenJinKfName nvarchar(50),
	@GenJinKfDepId int,
	@ExCompanyId int
)
AS
BEGIN
Declare @cSql varchar(4000)

Set @cSql='Update [Order] Set GenJinKfAccount='''+@GenJinKfAccount+''',GenJinKfName='''+@GenJinKfName+
	''',GenJinKfDepId='+Convert(varchar(20),@GenJinKfDepId)+'
	Where Id In(' + @Order_Id + ') And ExCompanyId='+Convert(varchar(20),@ExCompanyId)

Execute(@cSql)
END